check unusable index in oracle. There are any references about check unusable index in oracle in here. you can look below.